/**
 * Created by Administrator on 2015/9/8.
 */
var superM = {
    queryActiveAboutMe:'select y_admit.id,y_active.id activeId,subject,startTime,location,y_active.status activeStatus,y_admit.status admitStatus,applyTime,endTime  from y_active,y_admit,y_userInfo,y_activeDetail where y_admit.activeId=y_active.id and y_active.activeDetailId=y_activedetail.id and y_admit.userInfoId=y_userinfo.id and y_userinfo.id=? and subject like ?;',
    changeAdmitStatus:'update y_admit set status = ? where id = ?',
    cancelApply:'delete from y_admit where id = ?',
    queryComingActive:'select y_active.id activeId,y_activedetail.id activeDetailId,subject,startTime,endTime,location from y_active,y_activedetail where y_active.activeDetailId=y_activedetail.id and y_active.status = 1 and subject like ?  and y_active.id not in(select activeId from y_admit where y_admit.userInfoId = ?)'
};

module.exports = superM;